/****** Object:  Stored Procedure IDSSortsGetList    Script Date: Sunday, May 13, 2007 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spIDSSortsGetListOnIDS]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [spIDSSortsGetListOnIDS]
GO

		
CREATE PROCEDURE spIDSSortsGetListOnIDS
	
AS

SELECT
	[IDSSorts].[IDSSortID],
	[Name],
	[SortOrder],
	[IsDisplayed]
FROM
	[IDSSorts] 
WHERE [IsDisplayed]=1 
ORDER BY [SortOrder]

GO

	
 